FaNSLDSWork00

EntityType | Independent
Logical Entity Name | FaNSLDSWork00
Default Table Name | FaNSLDSWork00
Logical Only | NO
Owner | dbo
Definition |
Note |

FaNSLDSWork00 Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaNsldsWork00ID |  | INTEGER | NO |
FaISIR00ID |  | INTEGER | YES |
Name |  | CHAR(60) | YES |
SSN |  | CHAR(17) | YES |
TransactionProcessed |  | DATETIME | YES |
OverPaymentChangeFlag |  | CHAR(1) | YES |
DefaultChangeFlag |  | CHAR(1) | YES |
DefaultedLoanFlag |  | CHAR(1) | YES |
DischargedChangeFlag |  | CHAR(1) | YES |
DischargedLoanFlag |  | CHAR(1) | YES |
SatRepayChangeFlag |  | CHAR(1) | YES |
LoanSatRepayFlag |  | CHAR(1) | YES |
ActiveBankruptChangeFlag |  | CHAR(1) | YES |
ActiveBankruptcyFlag |  | CHAR(1) | YES |
PellOverPayFlag |  | CHAR(1) | YES |
PellOverPayContact |  | CHAR(12) | YES |
SEOGOverpayFlag |  | CHAR(1) | YES |
SEOGOverpayContact |  | CHAR(12) | YES |
PerkinsOverpayFlag |  | CHAR(1) | YES |
PerkinsOverpayContact |  | CHAR(12) | YES |
AggrSubsidizedBal |  | CHAR(8) | YES |
AggrSubsidizedDisbPending |  | CHAR(8) | YES |
AggrSubsidizedTotal |  | CHAR(8) | YES |
AggrCombinedBal |  | CHAR(8) | YES |
AggrCombinedDisbPending |  | CHAR(8) | YES |
AggrCombinedTotal |  | CHAR(8) | YES |
AggrConsolidateBal |  | CHAR(8) | YES |
AggrConsolidatedTotal |  | CHAR(8) | YES |
PerkinsLoanChangeFlag |  | CHAR(1) | YES |
PerkinsCumDisbAmt |  | CHAR(8) | YES |
PerkinsCurrYearDisbAmt |  | CHAR(8) | YES |
PerkinsFirstDisbPrior |  | CHAR(1) | YES |
PellPaymentChangeFlag |  | CHAR(1) | YES |
AdditionalPellFlag |  | CHAR(1) | YES |
PellSchoolCode1 |  | CHAR(8) | YES |
PellSchoolCode2 |  | CHAR(8) | YES |
PellSchoolCode3 |  | CHAR(8) | YES |
TransactionNumber1 |  | CHAR(2) | YES |
TransactionNumber2 |  | CHAR(2) | YES |
TransactionNumber3 |  | CHAR(2) | YES |
ScheduledAmount1 |  | CHAR(7) | YES |
ScheduledAmount2 |  | CHAR(7) | YES |
ScheduledAmount3 |  | CHAR(7) | YES |
AmountPaidToDate1 |  | CHAR(7) | YES |
AmountPaidToDate2 |  | CHAR(7) | YES |
AmountPaidToDate3 |  | CHAR(7) | YES |
RemainAmountToPay1 |  | CHAR(7) | YES |
RemainAmountToPay2 |  | CHAR(7) | YES |
RemainAmountToPay3 |  | CHAR(7) | YES |
PercentAwardUsed1 |  | CHAR(6) | YES |
PercentAwardUsed2 |  | CHAR(6) | YES |
PercentAwardUsed3 |  | CHAR(6) | YES |
LastUpdateDate1 |  | CHAR(8) | YES |
LastUpdateDate2 |  | CHAR(8) | YES |
LastUpdateDate3 |  | CHAR(8) | YES |
VerificationFlag1 |  | CHAR(3) | YES |
VerificationFlag2 |  | CHAR(3) | YES |
VerificationFlag3 |  | CHAR(3) | YES |
EFC1 |  | CHAR(4) | YES |
EFC2 |  | CHAR(4) | YES |
EFC3 |  | CHAR(4) | YES |
ChangeFlag1 |  | CHAR(1) | YES |
ChangeFlag2 |  | CHAR(1) | YES |
ChangeFlag3 |  | CHAR(1) | YES |
ChangeFlag4 |  | CHAR(1) | YES |
ChangeFlag5 |  | CHAR(1) | YES |
ChangeFlag6 |  | CHAR(1) | YES |
ChangeFlag7 |  | CHAR(1) | YES |
ChangeFlag8 |  | CHAR(1) | YES |
ChangeFlag9 |  | CHAR(1) | YES |
ChangeFlag10 |  | CHAR(1) | YES |
ChangeFlag11 |  | CHAR(1) | YES |
ChangeFlag12 |  | CHAR(1) | YES |
ProgramCode1 |  | CHAR(30) | YES |
ProgramCode2 |  | CHAR(30) | YES |
ProgramCode3 |  | CHAR(30) | YES |
ProgramCode4 |  | CHAR(30) | YES |
ProgramCode5 |  | CHAR(30) | YES |
ProgramCode6 |  | CHAR(30) | YES |
ProgramCode7 |  | CHAR(30) | YES |
ProgramCode8 |  | CHAR(30) | YES |
ProgramCode9 |  | CHAR(30) | YES |
ProgramCode10 |  | CHAR(30) | YES |
ProgramCode11 |  | CHAR(30) | YES |
ProgramCode12 |  | CHAR(30) | YES |
NetAmount1 |  | CHAR(8) | YES |
NetAmount2 |  | CHAR(8) | YES |
NetAmount3 |  | CHAR(8) | YES |
NetAmount4 |  | CHAR(8) | YES |
NetAmount5 |  | CHAR(8) | YES |
NetAmount6 |  | CHAR(8) | YES |
NetAmount7 |  | CHAR(8) | YES |
NetAmount8 |  | CHAR(8) | YES |
NetAmount9 |  | CHAR(8) | YES |
NetAmount10 |  | CHAR(8) | YES |
NetAmount11 |  | CHAR(8) | YES |
NetAmount12 |  | CHAR(8) | YES |
LoanBeginDate1 |  | CHAR(10) | YES |
LoanBeginDate2 |  | CHAR(10) | YES |
LoanBeginDate3 |  | CHAR(10) | YES |
LoanBeginDate4 |  | CHAR(10) | YES |
LoanBeginDate5 |  | CHAR(10) | YES |
LoanBeginDate6 |  | CHAR(10) | YES |
LoanBeginDate7 |  | CHAR(10) | YES |
LoanBeginDate8 |  | CHAR(10) | YES |
LoanBeginDate9 |  | CHAR(10) | YES |
LoanBeginDate10 |  | CHAR(10) | YES |
LoanBeginDate11 |  | CHAR(10) | YES |
LoanBeginDate12 |  | CHAR(10) | YES |
LoanEndDate1 |  | CHAR(10) | YES |
LoanEndDate2 |  | CHAR(10) | YES |
LoanEndDate3 |  | CHAR(10) | YES |
LoanEndDate4 |  | CHAR(10) | YES |
LoanEndDate5 |  | CHAR(10) | YES |
LoanEndDate6 |  | CHAR(10) | YES |
LoanEndDate7 |  | CHAR(10) | YES |
LoanEndDate8 |  | CHAR(10) | YES |
LoanEndDate9 |  | CHAR(10) | YES |
LoanEndDate10 |  | CHAR(10) | YES |
LoanEndDate11 |  | CHAR(10) | YES |
LoanEndDate12 |  | CHAR(10) | YES |
GaCode1 |  | CHAR(3) | YES |
GaCode2 |  | CHAR(3) | YES |
GaCode3 |  | CHAR(3) | YES |
GaCode4 |  | CHAR(3) | YES |
GaCode5 |  | CHAR(3) | YES |
GaCode6 |  | CHAR(3) | YES |
GaCode7 |  | CHAR(3) | YES |
GaCode8 |  | CHAR(3) | YES |
GaCode9 |  | CHAR(3) | YES |
GaCode10 |  | CHAR(3) | YES |
GaCode11 |  | CHAR(3) | YES |
GaCode12 |  | CHAR(3) | YES |
LoanSchoolCode1 |  | CHAR(8) | YES |
LoanSchoolCode2 |  | CHAR(8) | YES |
LoanSchoolCode3 |  | CHAR(8) | YES |
LoanSchoolCode4 |  | CHAR(8) | YES |
LoanSchoolCode5 |  | CHAR(8) | YES |
LoanSchoolCode6 |  | CHAR(8) | YES |
LoanSchoolCode7 |  | CHAR(8) | YES |
LoanSchoolCode8 |  | CHAR(8) | YES |
LoanSchoolCode9 |  | CHAR(8) | YES |
LoanSchoolCode10 |  | CHAR(8) | YES |
LoanSchoolCode11 |  | CHAR(8) | YES |
LoanSchoolCode12 |  | CHAR(8) | YES |
GradeLevel1 |  | CHAR(3) | YES |
GradeLevel2 |  | CHAR(3) | YES |
GradeLevel3 |  | CHAR(3) | YES |
GradeLevel4 |  | CHAR(3) | YES |
GradeLevel5 |  | CHAR(3) | YES |
GradeLevel6 |  | CHAR(3) | YES |
GradeLevel7 |  | CHAR(3) | YES |
GradeLevel8 |  | CHAR(3) | YES |
GradeLevel9 |  | CHAR(3) | YES |
GradeLevel10 |  | CHAR(3) | YES |
GradeLevel11 |  | CHAR(3) | YES |
GradeLevel12 |  | CHAR(3) | YES |
LoanContactCode1 |  | CHAR(8) | YES |
LoanContactCode2 |  | CHAR(8) | YES |
LoanContactCode3 |  | CHAR(8) | YES |
LoanContactCode4 |  | CHAR(8) | YES |
LoanContactCode5 |  | CHAR(8) | YES |
LoanContactCode6 |  | CHAR(8) | YES |
LoanContactCode7 |  | CHAR(8) | YES |
LoanContactCode8 |  | CHAR(8) | YES |
LoanContactCode9 |  | CHAR(8) | YES |
LoanContactCode10 |  | CHAR(8) | YES |
LoanContactCode11 |  | CHAR(8) | YES |
LoanContactCode12 |  | CHAR(8) | YES |
CurrentStatusCode1 |  | CHAR(2) | YES |
CurrentStatusCode2 |  | CHAR(2) | YES |
CurrentStatusCode3 |  | CHAR(2) | YES |
CurrentStatusCode4 |  | CHAR(2) | YES |
CurrentStatusCode5 |  | CHAR(2) | YES |
CurrentStatusCode6 |  | CHAR(2) | YES |
CurrentStatusCode7 |  | CHAR(2) | YES |
CurrentStatusCode8 |  | CHAR(2) | YES |
CurrentStatusCode9 |  | CHAR(2) | YES |
CurrentStatusCode10 |  | CHAR(2) | YES |
CurrentStatusCode11 |  | CHAR(2) | YES |
CurrentStatusCode12 |  | CHAR(2) | YES |
CurrentStatusDate1 |  | CHAR(10) | YES |
CurrentStatusDate2 |  | CHAR(10) | YES |
CurrentStatusDate3 |  | CHAR(10) | YES |
CurrentStatusDate4 |  | CHAR(10) | YES |
CurrentStatusDate5 |  | CHAR(10) | YES |
CurrentStatusDate6 |  | CHAR(10) | YES |
CurrentStatusDate7 |  | CHAR(10) | YES |
CurrentStatusDate8 |  | CHAR(10) | YES |
CurrentStatusDate9 |  | CHAR(10) | YES |
CurrentStatusDate10 |  | CHAR(10) | YES |
CurrentStatusDate11 |  | CHAR(10) | YES |
CurrentStatusDate12 |  | CHAR(10) | YES |
OutPrincipalBalance1 |  | CHAR(8) | YES |
OutPrincipalBalance2 |  | CHAR(8) | YES |
OutPrincipalBalance3 |  | CHAR(8) | YES |
OutPrincipalBalance4 |  | CHAR(8) | YES |
OutPrincipalBalance5 |  | CHAR(8) | YES |
OutPrincipalBalance6 |  | CHAR(8) | YES |
OutPrincipalBalance7 |  | CHAR(8) | YES |
OutPrincipalBalance8 |  | CHAR(8) | YES |
OutPrincipalBalance9 |  | CHAR(8) | YES |
OutPrincipalBalance10 |  | CHAR(8) | YES |
OutPrincipalBalance11 |  | CHAR(8) | YES |
OutPrincipalBalance12 |  | CHAR(8) | YES |
OutPrincipalBalanceDate1 |  | CHAR(10) | YES |
OutPrincipalBalanceDate2 |  | CHAR(10) | YES |
OutPrincipalBalanceDate3 |  | CHAR(10) | YES |
OutPrincipalBalanceDate4 |  | CHAR(10) | YES |
OutPrincipalBalanceDate5 |  | CHAR(10) | YES |
OutPrincipalBalanceDate6 |  | CHAR(10) | YES |
OutPrincipalBalanceDate7 |  | CHAR(10) | YES |
OutPrincipalBalanceDate8 |  | CHAR(10) | YES |
OutPrincipalBalanceDate9 |  | CHAR(10) | YES |
OutPrincipalBalanceDate10 |  | CHAR(10) | YES |
OutPrincipalBalanceDate11 |  | CHAR(10) | YES |
OutPrincipalBalanceDate12 |  | CHAR(10) | YES |
LoanContactType1 |  | CHAR(3) | YES |
LoanContactType2 |  | CHAR(3) | YES |
LoanContactType3 |  | CHAR(3) | YES |
LoanContactType4 |  | CHAR(3) | YES |
LoanContactType5 |  | CHAR(3) | YES |
LoanContactType6 |  | CHAR(3) | YES |
LoanContactType7 |  | CHAR(3) | YES |
LoanContactType8 |  | CHAR(3) | YES |
LoanContactType9 |  | CHAR(3) | YES |
LoanContactType10 |  | CHAR(3) | YES |
LoanContactType11 |  | CHAR(3) | YES |
LoanContactType12 |  | CHAR(3) | YES |
AdditionalLoansFlag |  | CHAR(1) | YES |
DateAdded |  | DATETIME | YES |
DateLstMod |  | DATETIME | YES |
UserId |  | INTEGER | YES |
AggrLoanChangeFlag |  | CHAR(1) | YES |
ts |  | TIMESTAMP/DATE | NO |

FaNSLDSWork00 Keys

Key Name | Key Type | Keys
FaNSLDSWork00_FaNsldsWork00ID_U_C_IDX | PrimaryKey | FaNsldsWork00ID

FaNSLDSWork00 Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaNSLDSWork00 Check Constraints

Check Constraint Name | CheckConstraint

FaNSLDSWork00 Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaNSLDSWork00 | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaNSLDSWork00 | NO |  |  |

FaNSLDSWork00 Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaNSLDSWork00 Data Movement Rules

Name | Type | Rule Text/Value